__author__ = "kiana";

from util.sqlalchemy_util import *;
from datetime import datetime;
from util.md5_util import *;

'''
Double_Color_Ball 对象
'''

class Double_Color_Ball(Base):
    # 指定表名
    __tablename__ = "double_color_ball";

    # 指定编码
    __table_args__ = {
        "mysql_charset":"utf8"
    }

    # 指定主键列
    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False);
    # 指定非主键列
    issue_no = Column(String(255));
    award_date = Column(Date);
    red_ball = Column(String(255));
    blue_ball = Column(String(255));
    total_sales = Column(Float);
    first_prize_number = Column(Integer);
    second_prize_number = Column(Integer);
    create_date = Column(DateTime);

if __name__ == '__main__':
    # 初始化 user 表格
    init_table();